pg Windows to PG FreeBSD

--0050450158a63988fb0484ecf2da
Content-Type: text/plain; charset=ISO-8859-1

hi

I have one install of postgresql in Windows, and a second in FreeBSD. Both
are the 8.4 version
I am trying to connect from the windows install to the FreeBSD server
install


psql -h 10.10.90.125 -U myUser -d template1

and the result is:


"Could not connect to server connection refused....is the server running on
host .... and accepting tcp/ip connections on port 5432?"

I searched in severa places, one of them is:

http://www.postgresql.org/docs/8.3/static/server-start.html

http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.h tml

http://www.postgresql.org/docs/8.4/static/runtime-config-con nection.html

http://www.cyberciti.biz/tips/postgres-allow-remote-access-t cp-connection.html

in addition to the manual,


I do not have the same problem when I try a Windows to Windows connection.


I already placed the "*" in the listen_addresses option and "host all all
10.10.90.0/24 trust".

I'm not sure what to do now, again, windows to windows there is no problem,

thanks

--0050450158a63988fb0484ecf2da
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Re: pg Windows to PG FreeBSD

On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda wro=
te:
> hi
>
> I have one install of postgresql in Windows, and a second in FreeBSD. Both
> are the 8.4 version
> I am trying to connect from the windows install to the FreeBSD server
> install
>
>
> psql -h 10.10.90.125 -U=A0myUser -d template1
>
> and the result is:
>
>
> "Could not connect to server connection refused....is the server running =
on
> host .... and accepting tcp/ip connections on port 5432?"

So, the windows machine can't get to port 5432 on the bsd machine.
The problem can be anything from a firewall (exxternal) to the app not
running on the host machine.

Does that same string work on the bsd box?

> I searched in severa places, one of them is:
> http://www.postgresql.org/docs/8.3/static/server-start.html
> http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.h tml
> http://www.postgresql.org/docs/8.4/static/runtime-config-con nection.html
> http://www.cyberciti.biz/tips/postgres-allow-remote-access-t cp-connection=
..html
> in addition to the manual,
>
> I do not have the same problem when I try a Windows to Windows connection.

Of course, the problem is likely that the bsd box isn't answering on
that port for whatever reason.

> I already placed the "*" in the listen_addresses option and=A0 "host all =
all
> 10.10.90.0/24 trust".

Where did you change this? On the bsd box or the windows box (should
be bsd) If on bsd did you then restart the server on bsd?

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: pg Windows to PG FreeBSD

--000e0cd2454667c68a0484f255df
Content-Type: text/plain; charset=ISO-8859-1

I appologize,

I did everything as stated in the manuals and more, but I did not remove the
comment character from the configuration file postgres.conf. The connection
from pg WIndows to pg Freebsd was succesful,

thanks for your reply



On Fri, Apr 23, 2010 at 4:11 PM, Scott Marlowe wrote:

> On Fri, Apr 23, 2010 at 2:05 PM, herbey zepeda
> wrote:
> > hi
> >
> > I have one install of postgresql in Windows, and a second in FreeBSD.
> Both
> > are the 8.4 version
> > I am trying to connect from the windows install to the FreeBSD server
> > install
> >
> >
> > psql -h 10.10.90.125 -U myUser -d template1
> >
> > and the result is:
> >
> >
> > "Could not connect to server connection refused....is the server running
> on
> > host .... and accepting tcp/ip connections on port 5432?"
>
> So, the windows machine can't get to port 5432 on the bsd machine.
> The problem can be anything from a firewall (exxternal) to the app not
> running on the host machine.
>
> Does that same string work on the bsd box?
>
> > I searched in severa places, one of them is:
> > http://www.postgresql.org/docs/8.3/static/server-start.html
> > http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.h tml
> > http://www.postgresql.org/docs/8.4/static/runtime-config-con nection.html
> >
> http://www.cyberciti.biz/tips/postgres-allow-remote-access-t cp-connection.html
> > in addition to the manual,
> >
> > I do not have the same problem when I try a Windows to Windows
> connection.
>
> Of course, the problem is likely that the bsd box isn't answering on
> that port for whatever reason.
>
> > I already placed the "*" in the listen_addresses option and "host all
> all
> > 10.10.90.0/24 trust".
>
> Where did you change this? On the bsd box or the windows box (should
> be bsd) If on bsd did you then restart the server on bsd?
>

--000e0cd2454667c68a0484f255df
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Re: pg Windows to PG FreeBSD

On Fri, Apr 23, 2010 at 8:30 PM, herbey zepeda wrote:
> I appologize,
>
> I did everything as stated in the manuals and more, but I did not remove the
> comment character from the configuration file postgres.conf. The connection
> from pg WIndows to pg Freebsd was succesful,

No need for an apology. You had a problem and came here for help.
That's what the list is for. Glad you got it figured out.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin